-
Re: Calculate Occurrences in a Month
Hi @MVZ give this one a try... It will count any dates that have the same month as today's month. Be sure your Source Range date column is an actual date type column. =COUNTIFS({Source Range}, IFERRO…1 · -
Re: QuickBooks Desktop and Smartsheet - Possible API Integration?
Hey @KT_H I'm working on an integration with Quickbooks and Smartsheet now for a client. It can be done in a couple of different ways. 1) Code the APIs for both Quickbooks and SS to talk to each othe…1 · -
Re: Need Help with Formula, want all project summary sheet to record most recent step completed
Hi CDS: It's possible! How many project sheets do you have? There are a few ways to make this happen: 1) Create cross sheet references (video on how to do that) from your summary sheet to index/colle…1 · -
Re: Ratio-Based Conditional Task Health Indicator
Hi Dom, how are you looking to calculate the duration elapsed? For instance: Start Date = 01/01/23 Finish Date = 06/01/23 Today's Date = 05/29/23 Days between Start and Finish = 151 Days between toda…1 · -
Re: How to color-band by duplicate entry
Where did you see those instructions? It that Chat GPT? :) That's interesting. The way I do this is add a Column (type checkbox) to your sheet. Call it Dup. Add this formula. Make it a column formula…1 ·